package com.zhiyou.mapper;

import java.sql.Date;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

import com.zhiyou.model.FYDormAttendance;

import net.sf.jsqlparser.statement.update.Update;

public interface SupervisorDormMapper {

	/*考勤首页*/
			//根据寝楼查询的考勤总数
			List<LinkedHashMap<String,String>> SelectByBuilding(@Param("DormCurrentDate")Date date,@Param("id")Integer id);
			//根据上面的方法来根据寝楼ID分组
			List<LinkedHashMap<String,String>> SelectByBuildingID(@Param("DormCurrentDate")Date date,@Param("id")Integer id);
			
			//根据教室查询
			List<LinkedHashMap<String,String>> SelectByClass(@Param("DormCurrentDate")Date date,@Param("id")Integer id);
			//根据上面的方法来根据班级ID分组
			List<LinkedHashMap<String,String>> SelectByClassID(@Param("DormCurrentDate")Date date,@Param("id")Integer id);
			
			//详情页的未归人数信息
			List<Map<String,String>> SelectByBuildingWeiGui(@Param("ids")Integer ids,@Param("buildingId")Integer building_id,@Param("DormCurrentDate")Date date,@Param("DormId")Integer dorm_id);
			//详情页已归人数的信息
			List<Map<String,String>> SelectByBuildingYiGui(@Param("ids")Integer ids,@Param("buildingId")Integer building_id,@Param("DormCurrentDate")Date date,@Param("DormId")Integer dorm_id);
			//详情页请假人数的信息
			List<Map<String,String>> SelectByBuildingQingJia(@Param("ids")Integer ids,@Param("buildingId")Integer building_id,@Param("DormCurrentDate")Date date,@Param("DormId")Integer dorm_id);

			//宿舍表的模糊查询
			List<Map<String,String>> selectByStudentName(@Param("student_name")String student_name);
			
			
			//修改学生考勤
			//修改学生考勤
			void updateDrom(FYDormAttendance fyDormAttendance);
			FYDormAttendance SelectByid(@Param("student_id")Integer student_id,@Param("dorm_current_date") Date dorm_current_date);
			
}
